Skip to main content

Create DML Right Join in dataset.

DML Right-Join tutorial: From this document you will learn to create the DML dataset which contains right join, here the right join connects the multiple tables to make the DML dataset.

Follow steps to create DML Right-join dataset in OPNBI:-

  1. Go to Dataset section, Click on Create DML from bottom menu bar. As shown in figure below:

Docusaurus Slash Introduction

  1. The Create Data Module dialog box looks as shown in figure below:

Docusaurus Slash Introduction

  1. Enter Following detail in DML Module dialog box:
  • Name: DML Right Join
  • Source: ClassicModels
  • Expend tables from left side table view, As shown in figure below:

Docusaurus Slash Introduction

  1. Drag and Drop the CUSTOMERS table from the Table list to Right side diagram box, then select all the columns of CUSTOMERS table, click on submit button.

Docusaurus Slash Introduction

  1. After submitting, the diagram box will look like the figure below:

Docusaurus Slash Introduction

  1. Drag and drop the OFFICES from the left table menu to right diagram box. as shown in figure below:

Docusaurus Slash Introduction

  1. Select all the column from OFFICES table, and click submit button.

Docusaurus Slash Introduction

  1. After adding CUSTOMERS and OFFICES from the table list, the diagram box looks like the figure below:

Docusaurus Slash Introduction

  1. Drag the COUNTRY column from Customers to Offices.

Docusaurus Slash Introduction

  1. Click on the thread between two tables, to add DML configuration.

Docusaurus Slash Introduction

  1. The DML configuration control box will open, Select the Right Join radio button and click on Submit button, as shown in figure below:

Docusaurus Slash Introduction

  1. The Connection between two tables will looks as shown in figure below:

Docusaurus Slash Introduction

Note: Click on Submit to save the dataset.

  1. Create Dashboard from the Visualization section. Example name: DML Right Join, as shown in figure below:

Docusaurus Slash Introduction

  1. After loading the Dashboard, Find Analysis Icon from the left vertical menu bar, click on the icon to load analysis widget in dashboard.

Docusaurus Slash Introduction

  1. The Analysis widget will get load in dashboard automatically after clicking on the analysis icon. > Select the Dataset(dml): DML Right Join.

Docusaurus Slash Introduction

  1. Click on Field icon from Analysis widget, then the Analysis Selection dialog box will open, as shown in figure below:

Docusaurus Slash Introduction

  1. The two table will get load the left side box of DML view, Now expends the OFFICES table.

Docusaurus Slash Introduction

  1. Drag and drop Country column in the Rows box, the Values box will take the Count of Country automatically as you drag the country in Rows click on the Save to see the reflection of the selected data in widget.

Docusaurus Slash Introduction

  1. The output of the widget will look like available figure below:

Docusaurus Slash Introduction

More features of OPNBI as follows:​

DML Inner Join​

DML Left Join​

DML Right Join​

DML Language Alias​

DML using Parameter​

DML with multiple join condition​